/*
 Navicat Premium Data Transfer

 Source Server         : wwenj
 Source Server Type    : MySQL
 Source Server Version : 80012
 Source Host           : localhost:3306
 Source Schema         : trip

 Target Server Type    : MySQL
 Target Server Version : 80012
 File Encoding         : 65001

 Date: 10/06/2019 23:46:42
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for total_data
-- ----------------------------
DROP TABLE IF EXISTS `total_data`;
CREATE TABLE `total_data` (
  `userId` int(11) NOT NULL AUTO_INCREMENT,
  `allWalk` varchar(255) DEFAULT NULL,
  `allRun` varchar(255) DEFAULT NULL,
  `allCycle` varchar(255) DEFAULT NULL,
  `allDrive` varchar(255) DEFAULT NULL,
  `allBus` varchar(255) DEFAULT NULL,
  `allTaxi` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of total_data
-- ----------------------------
BEGIN;
INSERT INTO `total_data` VALUES (1, '87.39', '46.59', '81.40', '40.5', '94.37', '44.78');
INSERT INTO `total_data` VALUES (2, '10.3', '40.7', '17.9', '33.5', '5.8', '12.4');
INSERT INTO `total_data` VALUES (3, '12.4', '44.9', '32.0', '47.2', '12.4', '22.9');
COMMIT;

-- ----------------------------
-- Table structure for trip_data
-- ----------------------------
DROP TABLE IF EXISTS `trip_data`;
CREATE TABLE `trip_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `tripType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `distance` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` varchar(255) DEFAULT NULL,
  `trajectory` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `Calorie` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `speed` varchar(255) DEFAULT NULL,
  `price` varchar(255) DEFAULT NULL,
  `startPlace` varchar(255) DEFAULT NULL,
  `endPlace` varchar(255) DEFAULT NULL,
  `startCode` varchar(255) DEFAULT NULL,
  `endCode` varchar(255) DEFAULT NULL,
  `mark` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=241 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of trip_data
-- ----------------------------
BEGIN;
INSERT INTO `trip_data` VALUES (101, 1, 'trip', '骑车出行', '1.98', '2018-04-23', '1:32:43', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '12.4', '19.2', NULL, NULL, NULL, NULL, NULL, '上街买菜');
INSERT INTO `trip_data` VALUES (102, 3, 'trip', '骑车出行', '1.72', '2018-04-23', '1:32:43', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '12.4', '19.2', NULL, NULL, NULL, NULL, NULL, '上街买菜');
INSERT INTO `trip_data` VALUES (103, 3, 'trip', '骑车出行', '1.72', '2018-04-23', '1:32:43', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '12.4', '19.2', NULL, NULL, NULL, NULL, NULL, '上街买菜');
INSERT INTO `trip_data` VALUES (104, 3, 'trip', '骑车出行', '1.72', '2018-04-23', '1:32:43', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '12.4', '19.2', NULL, NULL, NULL, NULL, NULL, '上街买菜');
INSERT INTO `trip_data` VALUES (105, 3, 'trip', '骑车出行', '1.72', '2018-04-23', '1:32:43', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '12.4', '19.2', NULL, NULL, NULL, NULL, NULL, '上街买菜');
INSERT INTO `trip_data` VALUES (106, 3, 'trip', '骑车出行', '1.72', '2018-04-23', '1:32:43', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '12.4', '19.2', NULL, NULL, NULL, NULL, NULL, '上街买菜');
INSERT INTO `trip_data` VALUES (107, 1, 'trip', '徒步出行', '3.07', '2019-04-15', '32:43', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '33.5', '76.0', NULL, NULL, NULL, NULL, NULL, '上街买菜');
INSERT INTO `trip_data` VALUES (108, 1, 'trip', '徒步出行', '3.07', '2019-04-15', '32:43', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '33.5', '76.0', NULL, NULL, NULL, NULL, NULL, '大家好，我是蔡徐坤，我擅长，唱，跳，rap！');
INSERT INTO `trip_data` VALUES (109, 2, 'trip', '徒步出行', '3.07', '2019-04-15', '32:43', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '33.5', '76.0', NULL, NULL, NULL, NULL, NULL, '大家好，我是蔡徐坤，我擅长，唱，跳，rap！');
INSERT INTO `trip_data` VALUES (110, 3, 'trip', '徒步出行', '3.07', '2019-04-15', '32:43', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '33.5', '76.0', NULL, NULL, NULL, NULL, NULL, '大家好，我是蔡徐坤，我擅长，唱，跳，rap！');
INSERT INTO `trip_data` VALUES (111, 1, 'trip', '驾车出行', '7.85', '2019-04-29', '2:65', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '98.7', '16.5', NULL, NULL, NULL, NULL, NULL, '出门看电影，好棒');
INSERT INTO `trip_data` VALUES (112, 1, 'trip', '驾车出行', '7.85', '2019-04-29', '2:65', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '98.7', '16.5', NULL, NULL, NULL, NULL, NULL, '出门看电影，好棒');
INSERT INTO `trip_data` VALUES (113, 3, 'trip', '驾车出行', '7.85', '2019-04-29', '2:65', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '98.7', '16.5', NULL, NULL, NULL, NULL, NULL, '出门看电影，好棒');
INSERT INTO `trip_data` VALUES (114, 1, 'trip', '跑步出行', '3.90', '2019-05-12', '2:43', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '123.7', '35.9', NULL, NULL, NULL, NULL, NULL, '上街买菜');
INSERT INTO `trip_data` VALUES (115, 1, 'trip', '跑步出行', '3.90', '2019-05-12', '2:43', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '123.7', '35.9', NULL, NULL, NULL, NULL, NULL, '去图书馆复习功课，加油');
INSERT INTO `trip_data` VALUES (116, 1, 'trip', '跑步出行', '3.90', '2019-05-12', '2:43', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '123.7', '35.9', NULL, NULL, NULL, NULL, NULL, '大家好，我是蔡徐坤，我擅长，唱，跳，rap！');
INSERT INTO `trip_data` VALUES (117, 1, 'trip', '跑步出行', '3.90', '2019-05-12', '2:43', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '123.7', '35.9', NULL, NULL, NULL, NULL, NULL, '大家好，我是蔡徐坤，我擅长，唱，跳，rap！');
INSERT INTO `trip_data` VALUES (118, 2, 'trip', '跑步出行', '3.90', '2019-05-12', '2:43', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '123.7', '35.9', NULL, NULL, NULL, NULL, NULL, '大家好，我是蔡徐坤，我擅长，唱，跳，rap！');
INSERT INTO `trip_data` VALUES (119, 3, 'trip', '跑步出行', '3.90', '2019-05-12', '2:43', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '123.7', '35.9', NULL, NULL, NULL, NULL, NULL, '去图书馆复习功课，加油');
INSERT INTO `trip_data` VALUES (120, 1, 'traffic', '单车/电车', '22.7', '2019-05-21', '10:32:43', NULL, NULL, NULL, '4', '西二旗', '昌平区', '116.306295,40.053034', '116.231204,40.22066', '出门看电影，好棒');
INSERT INTO `trip_data` VALUES (121, 1, 'traffic', '出租车', '22.7', '2019-05-21', '10:32:43', NULL, NULL, NULL, '4', '西二旗(地铁站)', '昌平区', '116.306295,40.053034', '116.231204,40.22066', '去图书馆复习功课，加油');
INSERT INTO `trip_data` VALUES (122, 1, 'traffic', '公交/地铁', '22.7', '2019-05-21', '10:32:43', NULL, NULL, NULL, '4', '西二旗', '昌平区', '116.306295,40.053034', '116.231204,40.22066', '出门看电影，好棒');
INSERT INTO `trip_data` VALUES (125, 1, 'traffic', '公交/地铁', '22.7', '2019-05-27', '10:32:43', NULL, NULL, NULL, '4', '西二旗', '昌平区', '116.306295,40.053034', '116.231204,40.22066', '大家好，我是蔡徐坤，我擅长，唱，跳，rap！');
INSERT INTO `trip_data` VALUES (127, 1, 'traffic', '单车/电车', '22.7', '2019-05-27', '10:32:43', NULL, NULL, NULL, '4', '望京西站', '北京站', '116.306295,40.053034', '116.231204,40.22066', '去图书馆复习功课，加油');
INSERT INTO `trip_data` VALUES (128, 1, 'traffic', '步行', '22.7', '2019-05-23', '10:32:43', NULL, NULL, NULL, '4', '西二旗(地铁站)', '昌平区', '116.306295,40.053034', '116.231204,40.22066', '出门看电影，好棒');
INSERT INTO `trip_data` VALUES (130, 2, 'traffic', '公交/地铁', '22.7', '2019-05-27', '10:32:43', NULL, NULL, NULL, '4', '西二旗', '昌平区', '116.306295,40.053034', '116.231204,40.22066', '大家好，我是蔡徐坤，我擅长，唱，跳，rap！');
INSERT INTO `trip_data` VALUES (131, 2, 'traffic', '出租车', '22.7', '2019-05-23', '10:32:43', NULL, NULL, NULL, '4', '西二旗(地铁站)', '昌平区', '116.306295,40.053034', '116.231204,40.22066', '去图书馆复习功课，加油');
INSERT INTO `trip_data` VALUES (135, 2, 'traffic', '公交/地铁', '22.7', '2019-05-27', '10:32:43', NULL, NULL, NULL, '4', '西二旗', '昌平区', '116.306295,40.053034', '116.231204,40.22066', '大家好，我是蔡徐坤，我擅长，唱，跳，rap！');
INSERT INTO `trip_data` VALUES (140, 2, 'trip', '徒步出行', '1.19', '2019-05-19', '00:01', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.5608726,43.9200321]]', '113.3', '4284.00', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `trip_data` VALUES (141, 2, 'trip', '自驾出行', '1.19', '2019-05-19', '00:03', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.5608726,43.9200321]]', '113.3', '1428.00', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `trip_data` VALUES (142, 2, 'trip', '跑步出行', '1.20', '2019-05-19', '00:02', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.56080259999999,43.9198854]]', '114.2', '2160.00', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `trip_data` VALUES (143, 2, 'trip', '徒步出行', '1.20', '2019-05-19', '00:02', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.56090909999999,43.9198181]]', '114.2', '2160.00', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `trip_data` VALUES (144, 2, 'trip', '骑行出行', '1.20', '2019-05-19', '00:05', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.56090909999999,43.9198181]]', '114.2', '864.00', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `trip_data` VALUES (145, 2, 'trip', '骑行出行', '1.20', '2019-05-19', '00:00', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.56090909999999,43.9198181]]', '114.2', '0', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `trip_data` VALUES (146, 2, 'trip', '骑行出行', '1.20', '2019-05-19', '00:16', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.5607469,43.9199531]]', '114.2', '270.00', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `trip_data` VALUES (147, 2, 'trip', '徒步出行', '1.20', '2019-05-19', '00:04', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.56075179999999,43.9199488]]', '114.2', '1080.00', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `trip_data` VALUES (151, 2, 'trip', '徒步出行', '1.22', '2019-05-19', '00:19', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.56063839999999,43.9198306]]', '116.1', '231.16', NULL, NULL, NULL, NULL, NULL, '备注备注测试测试备注备注测试测试备注备注测试测试');
INSERT INTO `trip_data` VALUES (152, 2, 'trip', '徒步出行', '1.22', '2019-05-19', '00:08', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.5606555,43.919781799999996]]', '116.1', '549.00', NULL, NULL, NULL, NULL, NULL, '备注备注备注备注备注备注备注备注备注备注');
INSERT INTO `trip_data` VALUES (153, 2, 'trip', '徒步出行', '1.21', '2019-05-20', '00:04', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.56067519999998,43.919824899999995]]', '115.2', '1089.00', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (155, 2, 'traffic', '公交/地铁', '8.42', '2019-05-20', '16:25:28', NULL, NULL, NULL, '0', '西二旗智学苑', '五道口(地铁站)', '116.310966, 40.05081', '116.337742, 39.992894', '宝珠测试');
INSERT INTO `trip_data` VALUES (156, 1, 'trip', '自驾出行', '1.20', '2019-05-19', '00:15', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.5608601,43.9199191]]', '114.2', '288.00', NULL, NULL, NULL, NULL, NULL, '备注备注备注备注');
INSERT INTO `trip_data` VALUES (157, 1, 'traffic', '公交/地铁', '25.83', '2019-05-20', '15:40:9', NULL, NULL, NULL, '2', '西二旗(地铁站)', '望京SOHO', '116.306295, 40.053034', '116.48105, 39.996794', '备注');
INSERT INTO `trip_data` VALUES (158, 1, 'trip', '跑步出行', '0', '2019-05-21', '00:32', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '0.0', '0.00', NULL, NULL, NULL, NULL, NULL, '移动端');
INSERT INTO `trip_data` VALUES (159, 1, 'trip', '徒步出行', '0', '2019-05-21', '00:05', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '0.0', '0.00', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (160, 1, 'trip', '跑步出行', '0.97', '2019-05-22', '00:36', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.5633043,43.9210147]]', '92.3', '97.00', NULL, NULL, NULL, NULL, NULL, '11111');
INSERT INTO `trip_data` VALUES (161, 1, 'traffic', '公交/地铁', '7.58', '2019-05-23', '18:47:52', NULL, NULL, NULL, '2', '西二旗(地铁站)', '五道口(地铁站)', '116.306295, 40.053034', '116.337742, 39.992894', '11');
INSERT INTO `trip_data` VALUES (162, 1, 'trip', '徒步出行', '0.96', '2019-05-23', '00:04', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.56345060000001,43.9210151]]', '91.4', '864.00', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (163, 1, 'trip', '徒步出行', '1.20', '2019-05-24', '00:05', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.5607929,43.919886999999996]]', '114.2', '864.00', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (164, 1, 'trip', '徒步出行', '1.20', '2019-05-24', '00:11', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.5607929,43.919886999999996]]', '114.2', '392.73', NULL, NULL, NULL, NULL, NULL, '出门买菜');
INSERT INTO `trip_data` VALUES (165, 1, 'trip', '徒步出行', '0', '2019-05-24', '00:02', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '0.0', '0.00', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (166, 1, 'trip', '骑行出行', '2.21', '2019-05-25', '00:47', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '210.4', '169.28', NULL, NULL, NULL, NULL, NULL, '出门买菜，今天做红烧肉！！');
INSERT INTO `trip_data` VALUES (167, 1, 'trip', '骑行出行', '3.75', '2019-05-25', '00:26', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '357.0', '519.23', NULL, NULL, NULL, NULL, NULL, '买菜做饭，今天做红烧肉！！');
INSERT INTO `trip_data` VALUES (168, 1, 'trip', '骑行出行', '1.20', '2019-05-25', '00:01', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.5608497,43.9199433]]', '114.2', '4320.00', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (169, 1, 'traffic', '公交/地铁', '7.58', '2019-05-25', '15:52:8', NULL, NULL, NULL, '2', '西二旗(地铁站)', '五道口(地铁站)', '116.306295, 40.053034', '116.337742, 39.992894', '出门上班！！');
INSERT INTO `trip_data` VALUES (181, 1, 'trip', '徒步出行', '0', '2019-05-22', '00:06', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '0.0', '0.00', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (182, 1, 'trip', '徒步出行', '20', '2019-05-22', '00:24', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '1904.0', '3000.00', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (183, 1, 'trip', '跑步出行', '22', '2019-05-22', '00:16', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '2094.4', '4950.00', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (184, 1, 'trip', '骑行出行', '10', '2019-05-22', '00:14', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '952.0', '2571.43', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (185, 1, 'trip', '自驾出行', '10', '2019-05-23', '00:26', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '952.0', '1384.62', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (186, 1, 'trip', '自驾出行', '10.5', '2019-05-24', '00:04', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '999.6', '9450.00', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (187, 1, 'trip', '自驾出行', '1', '2019-05-24', '00:01', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '95.2', '3600.00', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (188, 1, 'trip', '自驾出行', '1', '2019-05-24', '00:08', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '95.2', '450.00', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (189, 1, 'trip', '徒步出行', '1', '2019-05-25', '00:06', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '95.2', '600.00', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (190, 1, 'trip', '自驾出行', '4', '2019-05-25', '00:02', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '380.8', '7200.00', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (191, 1, 'trip', '自驾出行', '5', '2019-05-25', '00:00', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '476.0', '0', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (192, 1, 'trip', '自驾出行', '2', '2019-05-22', '00:00', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '190.4', '0', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (193, 1, 'trip', '自驾出行', '2', '2019-05-20', '00:00', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '190.4', '0', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (194, 1, 'trip', '自驾出行', '2', '2019-05-20', '00:01', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '190.4', '7200.00', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (195, 1, 'trip', '自驾出行', '2', '2019-05-20', '00:03', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '190.4', '2400.00', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (196, 1, 'trip', '自驾出行', '1', '2019-05-20', '00:00', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '95.2', '0', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (197, 1, 'traffic', '公交/地铁', '7.79', '2019-05-26', '21:11:3', NULL, NULL, NULL, '0', '西二旗(地铁站)', '五道口', '116.306295, 40.053034', '116.338611, 39.992552', '未备注');
INSERT INTO `trip_data` VALUES (198, 1, 'traffic', '公交/地铁', '7.79', '2019-05-26', '21:14:2', NULL, NULL, NULL, '0', '西二旗(地铁站)', '五道口', '116.306295, 40.053034', '116.338611, 39.992552', '未备注');
INSERT INTO `trip_data` VALUES (199, 1, 'traffic', '公交/地铁', '7.79', '2019-05-26', '21:17:19', NULL, NULL, NULL, '0', '西二旗(地铁站)', '五道口', '116.306295, 40.053034', '116.338611, 39.992552', '未备注');
INSERT INTO `trip_data` VALUES (200, 1, 'traffic', '公交/地铁', '25.83', '2019-05-26', '21:18:5', NULL, NULL, NULL, '0', '西二旗(地铁站)', '望京SOHO', '116.306295, 40.053034', '116.48105, 39.996794', '未备注');
INSERT INTO `trip_data` VALUES (201, 1, 'traffic', '公交/地铁', '27.33', '2019-05-26', '21:20:23', NULL, NULL, NULL, '0', '西二旗小学', '望京1号', '116.311052, 40.050092', '116.500131, 40.002891', '未备注');
INSERT INTO `trip_data` VALUES (202, 1, 'traffic', '公交/地铁', '24.02', '2019-05-26', '21:21:2', NULL, NULL, NULL, '0', '望京西园', '西二旗(地铁站)', '116.474395, 40.004173', '116.306295, 40.053034', '未备注');
INSERT INTO `trip_data` VALUES (203, 1, 'traffic', '公交/地铁', '24.02', '2019-05-26', '21:21:48', NULL, NULL, NULL, '0', '望京西园', '西二旗(地铁站)', '116.474395, 40.004173', '116.306295, 40.053034', '未备注');
INSERT INTO `trip_data` VALUES (206, 1, 'traffic', '步行', '19.77', '2019-05-27', '1:21:24', NULL, NULL, NULL, '0', '西二旗(地铁站)', '望京SOHO', '116.306295, 40.053034', '116.48105, 39.996794', '未备注');
INSERT INTO `trip_data` VALUES (207, 1, 'traffic', '单车/电车', '18.91', '2019-05-27', '1:22:23', NULL, NULL, NULL, '0', '西二旗智学苑', '望京(地铁站)', '116.310966, 40.05081', '116.469409, 39.998521', '未备注');
INSERT INTO `trip_data` VALUES (208, 1, 'trip', '徒步出行', '0.69', '2019-05-27', '00:05', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.56633327908003,43.922300075955],[126.56633327908003,43.922300075955]]', '65.7', '496.80', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (209, 1, 'traffic', '单车/电车', '8.73', '2019-05-27', '16:10:42', NULL, NULL, NULL, '0', '西二旗(地铁站)', '五道口(地铁站)', '116.306295, 40.053034', '116.337742, 39.992894', '111111');
INSERT INTO `trip_data` VALUES (210, 1, 'trip', '徒步出行', '0.68', '2019-05-27', '00:02', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.566459960938,43.922350802952]]', '64.7', '1224.00', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (214, 1, 'traffic', '单车/电车', '20.96', '2019-05-27', '16:25:23', NULL, NULL, NULL, '0', '西二旗(地铁站)', '望京SOHO', '116.306295, 40.053034', '116.48105, 39.996794', '2222222');
INSERT INTO `trip_data` VALUES (217, 1, 'trip', '徒步出行', '0.68', '2019-05-27', '00:13', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.56640597873297,43.922284884983]]', '64.7', '188.31', NULL, NULL, NULL, NULL, NULL, '火狐测试火狐测试火狐测试！');
INSERT INTO `trip_data` VALUES (218, 1, 'trip', '徒步出行', '0', '2019-05-28', '00:07', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199]]', '0.0', '0.00', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (219, 1, 'trip', '徒步出行', '0.68', '2019-05-28', '00:03', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.566433105469,43.922309027778],[126.566433105469,43.922312011719],[126.56641791449698,43.922297905816],[126.56641303168499,43.922294108073]]', '64.7', '816.00', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (220, 1, 'trip', '徒步出行', '0.68', '2019-05-29', '00:21', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.56643907335103,43.922263997396],[126.56643907335103,43.922263997396],[126.56643907335103,43.922263997396],[126.56643907335103,43.922263997396],[126.56643907335103,43.922263997396]]', '64.7', '116.57', NULL, NULL, NULL, NULL, NULL, '11');
INSERT INTO `trip_data` VALUES (221, 1, 'traffic', '步行', '18.60', '2019-05-29', '13:26:52', NULL, NULL, NULL, '4', '西二旗(地铁站)', '望京西园', '116.306295, 40.053034', '116.474395, 40.004173', '111');
INSERT INTO `trip_data` VALUES (222, 1, 'trip', '跑步出行', '0.68', '2019-05-29', '00:03', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.56647298177097,43.922273763021],[126.56647298177097,43.922273763021]]', '64.7', '816.00', NULL, NULL, NULL, NULL, NULL, '999');
INSERT INTO `trip_data` VALUES (223, 1, 'trip', '跑步出行', '0.69', '2019-06-01', '03:25', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.56642008463598,43.922284884983],[126.56643798828202,43.92231608073],[126.566429036459,43.922297092014],[126.56641710069499,43.92228108724]]', '65.7', '12.12', NULL, NULL, NULL, NULL, NULL, '答辩答辩答辩！！！');
INSERT INTO `trip_data` VALUES (224, 1, 'traffic', '步行', '8.48', '2019-06-01', '17:50:22', NULL, NULL, NULL, '8', '西二旗(地铁站)', '五道口(地铁站)', '116.306295, 40.053034', '116.337742, 39.992894', '答辩答辩答辩@@@@');
INSERT INTO `trip_data` VALUES (231, 1, 'trip', '跑步出行', '0.68', '2019-06-04', '01:16', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.56648491753504,43.922322591146]]', '64.7', '32.21', NULL, NULL, NULL, NULL, NULL, '测试11111');
INSERT INTO `trip_data` VALUES (232, 1, 'traffic', '公交/地铁', '12.92', '2019-06-04', '14:55:55', NULL, NULL, NULL, '0', '西二旗(地铁站)', '中关村', '116.306295, 40.053034', '116.319802, 39.98294', '11');
INSERT INTO `trip_data` VALUES (233, 1, 'trip', '徒步出行', '0.68', '2019-06-09', '00:05', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.56640299479199,43.922329915365],[126.56640299479199,43.922329915365]]', '64.7', '489.60', NULL, NULL, NULL, NULL, NULL, '12121212122');
INSERT INTO `trip_data` VALUES (234, 1, 'trip', '跑步出行', '0.68', '2019-06-09', '00:26', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.56639811197999,43.922373046875],[126.56645914713602,43.922391764323],[126.56645914713602,43.922391764323],[126.56645914713602,43.922391764323]]', '64.7', '94.15', NULL, NULL, NULL, NULL, NULL, '11111');
INSERT INTO `trip_data` VALUES (235, 1, 'traffic', '出租车', '10.88', '2019-06-09', '16:31:44', NULL, NULL, NULL, '2', '西二旗(地铁站)', '中关村', '116.306295, 40.053034', '116.319802, 39.98294', '未备注');
INSERT INTO `trip_data` VALUES (236, 1, 'trip', '骑行出行', '0.68', '2019-06-10', '00:11', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.56639892578198,43.922380913629]]', '64.7', '222.55', NULL, NULL, NULL, NULL, NULL, '未备注');
INSERT INTO `trip_data` VALUES (237, 1, 'trip', '徒步出行', '0.50', '2019-06-10', '00:04', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.56896972656301,43.923070475261],[126.56896972656301,43.923070475261]]', '47.6', '450.00', NULL, NULL, NULL, NULL, NULL, '99999');
INSERT INTO `trip_data` VALUES (238, 1, 'trip', '徒步出行', '0.47', '2019-06-10', '00:11', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.56982557508701,43.923534884983],[126.56982557508701,43.923534884983]]', '44.7', '153.82', NULL, NULL, NULL, NULL, NULL, '9999999');
INSERT INTO `trip_data` VALUES (239, 1, 'traffic', '公交/地铁', '25.83', '2019-06-10', '9:18:4', NULL, NULL, NULL, '2', '望京SOHO', '西二旗(地铁站)', '116.48105, 39.996794', '116.306295, 40.053034', '未备注');
INSERT INTO `trip_data` VALUES (240, 1, 'trip', '徒步出行', '0.43', '2019-06-10', '00:49', '[[126.567402,43.923187],[126.567402,43.923129],[126.56744,43.923098],[126.56759,43.923024],[126.567794,43.923024],[126.567928,43.922912],[126.568169,43.922819],[126.568486,43.922723],[126.568598,43.922881],[126.568727,43.923074],[126.56884,43.92319],[126.569274,43.923055],[126.569564,43.92348],[126.569859,43.923944],[126.569172,43.924199],[126.56987765842098,43.92409233941],[126.56987765842098,43.92409233941],[126.56987765842098,43.92409233941],[126.56987765842098,43.92409233941],[126.56987765842098,43.92409233941],[126.56987765842098,43.92409233941],[126.56987765842098,43.92409233941],[126.56987765842098,43.92409233941],[126.56987765842098,43.92409233941],[126.56987765842098,43.92409233941],[126.56987765842098,43.92409233941],[126.56987765842098,43.92409233941],[126.56987765842098,43.92409233941]]', '40.9', '31.59', NULL, NULL, NULL, NULL, NULL, '答辩');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `userId` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(255) DEFAULT NULL,
  `passWord` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, '15330734121', '12345');
INSERT INTO `user` VALUES (2, '15330734122', '12345');
INSERT INTO `user` VALUES (3, '15330734123', '12345');
COMMIT;

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `name` varchar(255) DEFAULT NULL,
  `age` int(10) DEFAULT NULL,
  `userId` int(11) NOT NULL AUTO_INCREMENT,
  `address` varchar(255) DEFAULT NULL,
  `Marriage` varchar(255) DEFAULT NULL,
  `userName` varchar(255) DEFAULT NULL,
  `img` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `sex` varchar(255) DEFAULT NULL,
  `identity` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`userId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of user_info
-- ----------------------------
BEGIN;
INSERT INTO `user_info` VALUES ('王文健', 18, 1, '天津市宝坻区', '单身', '15330734121', '', '男', '开发者');
INSERT INTO `user_info` VALUES ('李二狗', 22, 2, '吉林省吉林市', '已婚', '15330734122', '', '女', '管理员');
INSERT INTO `user_info` VALUES ('王刚蛋', 18, 3, '北京市朝阳区', '单身', '15330734123', '', '女', '普通用户');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
